Released on = May 5, 2006, 4:08 pm

Press Release Author = Alba Spectrum Group

Industry = Computers

Press Release Summary = New name for Microsoft Great Plains or former Great Plains
Dynamics is Microsoft Dynamics GP. Microsoft Dynamics GP 9.0 is definitely new
product, comparing to old GPS Dynamics, however if you use so-called "fat" client -
Microsoft Dexterity is still doing its graphical interface and database interaction
job.

Press Release Body = Alba Spectrum Group, USA/Canada: 1-866-528-0577,
1-630-961-5918, Europe: +44 20 8123 2580, +45 36 96 55 20, Mexico: 52-55-535-04027,
Brazil: 55-11-3444-4949, help@albaspectrum.com skype: albaspectrum

New name for Microsoft Great Plains or former Great Plains Dynamics is Microsoft
Dynamics GP. Microsoft Dynamics GP 9.0 is definitely new product, comparing to old
GPS Dynamics, however if you use so-called "fat" client - Microsoft Dexterity is
still doing its graphical interface and database interaction job.
If you have Microsoft Great Plains and support it for your company and have light or
heavy Great Plains customization, written in Dexterity - you need to know your
options in upgrading Great Plains or migrating it from ctree/Pervasive (not
supported by Microsoft since 2005) to MS SQL/MSDE.
Great Plains Dexterity is proprietary programming language/environment, which was
created in early 1990-th to provide platform / database / graphical interface
independence for Mac and Windows based Great Plains Dynamics. Today it is legacy
and Microsoft Business Solutions is phasing Dexterity out.
However Great Plains 8.0 and even 9.0 is Dexterity based application, so you have to
deal with it and it's customization.

Positive News. Prior to version 7.0 Great Plains had plans on expanding GP
functionality and so was changing tables structure - forcing Dexterity customization
to be analyzed and partially rewritten with each upgrade. Not any more - GP
structure stays the same - Microsoft is doing new modules acquisition and unifying
it's graphical interface to move all it's ERP packages: Great Plains, Solomon,
Navision and Axapta to web-based Microsoft Business Portal.

Negative News. Dexterity has possibility to customize existing Great Plains
screens, so called Alternative Great Plains forms. This was upgrade problem in the
past and it stays now - there is no way to do it in house (until you are willing to
pay for full-time internal developer - who is usually in the learning curve). You
got to bring in consultant.

Recommended approach. You should have the strategy to migrate Dexterity
customization to SQL, Crystal Reports, custom web publishing - Visual Studio.net and
slowly abandon Dexterity customization

1. Use SQL Stored procedures. Consider replacing dexterity data manipulation with
SQL stored procedures. Dexterity is cursor-driven language and it is not efficient
when processing huge datasets.
2. Use MS SQL Server Reporting Services or even Crystal Reports. Take advantage of
open and leading technology. SRS or Crystal Reports will eliminate the need in the
future for painstaking Dexterity reports upgrade. Base you Crystal report on the
SQL view or stored proc
3. Web Publishing. Use Visual Studio - it is easy to find specialists and have them
in staff. We are in the World when web publishing is very easy.


About Alba Spectrum Technologies. Alba Spectrum Technologies is joint venture of
several IT and business consulting companies, now operating as single business
entity. We have local presence in the Houston, Chicago, New York, Los Angeles, San
Diego, Dallas, Miami, Atlanta, Denver, Phoenix, New Orleans, Minneapolis, San
Francisco, LATAM & Brazil, Germany, Russia, South East Asia and Oceania. We believe
in the coexistence of Java (J2EE, EJB, Linux, Unix), Oracle and Microsoft (.Net, C#,
VB) platforms and systems and specialize in several product lines and cross platform
integration, customization, heterogeneous report design, plus we provide ERP/CRM
systems comparison and reviews, not being committed to just on MRP platform. We also
stake on XML cross-platform data interchange to be advanced in the coming decade.

Alba Spectrum Technologies websites:
http://www.albaspectrum.com
http://www.greatplains.com.mx
http://www.enterlogix.com.br
http://www.ronix-systems.de



Web Site = http://www.albaspectrum.com

Contact Details = Alba Spectrum Group, USA/Canada: 1-866-528-0577, 1-630-961-5918,
Europe: +44 20 8123 2580, +45 36 96 55 20, Mexico: 52-55-535-04027, Brazil:
55-11-3444-4949, help@albaspectrum.com skype: albaspectrum